﻿/* WHERE     (dbo.Parliamentarians.FormerMember = 0)*/
CREATE VIEW [dbo].[vwCurrentParties]
AS
SELECT DISTINCT dbo.Parties.RecId, dbo.Parties.FullName, dbo.Parties.ShortName, dbo.Parties.Precedence, dbo.Parties.AbbreviatedName
FROM         dbo.Parties INNER JOIN
                      dbo.Parliamentarians ON dbo.Parties.RecId = dbo.Parliamentarians.PartyRecId
WHERE     (dbo.Parliamentarians.FormerMember = 0)